Great Plains
The NetForum integration for Microsoft Dynamics GP requires the use of the GP Integration Manager to assist customers with importing the GP export files generated out of NetForum . Contact Great Plains support or a 3rd party consultant for more details on how to use the GP Integration Manager.
Abila does not support "how to?" questions related to 3rd party software such as Great Plains, which must be licensed separately from the 3rd party vendor by the customer.
Client Tasks and Requirements
- Client needs to have Microsoft Dynamics GP accounting software installed
- Client needs to have knowledge about how to import G/L files into Microsoft Dynamics GP
NetForum Tasks
This integration requires System Option setup.
Baseline File Layout
For GP integration, 2 export file (header and detail) will be created for each batch.
A sample baseline GP export detail file in summary format is shown below:
Example: batch name,g/l account,debit amount,credit amount BATCHNAME,1010000000,1340.00,0.00 BATCHNAME,3200000000,0.00,120.00 BATCHNAME,4300000000,0.00,1190.00 BATCHNAME,4400000000,0.00,30.00
A sample accompanying baseline GP export header file in summary format is shown below:
Example: batch name,batch date BATCHNAME,06/17/2009
A sample baseline GP export detail file in detail format is shown below:
Example: batch name,g/l account,debit amount,credit amount BATCHNAME,2000000000,495.00,0.00 BATCHNAME,3200000000,0.00,120.00 BATCHNAME,2000000000,0.00,15.00 BATCHNAME,2000000000,0.00,495.00 BATCHNAME,2000000000,0.00,695.00 BATCHNAME,2000000000,15.00,0.00 BATCHNAME,1010000000,15.00,0.00 BATCHNAME,4300000000,0.00,495.00 BATCHNAME,4300000000,0.00,695.00 BATCHNAME,1010000000,15.00,0.00 BATCHNAME,1010000000,120.00,0.00 BATCHNAME,1010000000,495.00,0.00 BATCHNAME,2000000000,15.00,0.00 BATCHNAME,2000000000,120.00,0.00 BATCHNAME,4400000000,0.00,15.00 BATCHNAME,1010000000,695.00,0.00 BATCHNAME,2000000000,0.00,15.00 BATCHNAME,2000000000,0.00,120.00 BATCHNAME,4400000000,0.00,15.00 BATCHNAME,2000000000,695.00,0.00
A sample accompanying baseline GP export header file in detail format is shown below:
Example: batch name,batch date BATCHNAME,06/17/2009
When the BatchExportMethod is set to detail the detail export file will contain a row for each ledger record created from the batch close process. When the BatchExportMethod is set to summary only one row will appear in the detail export file for each unique G/L Account that is not an Accounts Receivable account. Generally Abila recommends exporting in summary rather than detail.
Usage and Instructions
Once the file is generated after the post batch process from the NetForum batch profile, staff should go to the Microsoft Dynamics GP and import the file.
Additional Services
If the file layout shown above does not meet client's requirement and client requires Abila to make such change, additional fee will be needed to perform such change. The additional fee will be based on the complexity and the content of the file layout.
Tip: This process requires that you modify the BatchExportMethod system option.